Buttons and Numbers

3d · Apr 2, 2003

0o0o0o been a while since I was here last and its all had a lick of paint and a spring clean very nice...........well back to the quest!...What I am trying to do is make a simple stock list what I want to do is have a button on the screen so you can click it once and in the column a number 1 is added click again and it goes up to number 2 etc. and then I can have a seperate button to resest and clear the cells with the numbers in. I went one way with this but got lost

any help is appreciated

regards

3D

jimboy · Apr 2, 2003

Something like this

Sub test()

ActiveCell = ActiveCell + 1
End Sub

What cells do you want to clear? i.e. range

3d · Apr 2, 2003

instead of an active cell being selected how could I make it an actual cell ie D4 for instance? the range would be the numbers that are added in that column ie all of column d

jimboy · Apr 2, 2003

Try this;

Sub test()
Range("D4") = Range("D4") + 1
End Sub

'This will clear all of column D

Sub col_d_clear()
Range("D:D").ClearContents

End Sub

Sub clear()
'This will clear from D2 to the last cell with data in column D

Range("D2", Range("D65536").End(xlUp)).ClearContents

End Sub

3d · Apr 2, 2003

Thanx Jim much appreciated :D

Buttons and Numbers

3d

Board Regular

Excel Facts

jimboy

Well-known Member

3d

Board Regular

jimboy

Well-known Member

3d

Board Regular

Similar threads

Forum statistics

Share this page

Buttons and Numbers

3d

Board Regular

Excel Facts

jimboy

Well-known Member

3d

Board Regular

jimboy

Well-known Member

3d

Board Regular

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock